Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	6081641
Missing cells	3655639
Missing cells (%)	4.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	696.0 MiB
Average record size in memory	120.0 B

Variable types

Categorical	9
Numeric	6

Alerts

`ride_id` has a high cardinality: 6081641 distinct values	High cardinality
`started_at` has a high cardinality: 5125092 distinct values	High cardinality
`ended_at` has a high cardinality: 5138667 distinct values	High cardinality
`start_station_name` has a high cardinality: 1702 distinct values	High cardinality
`start_station_id` has a high cardinality: 1318 distinct values	High cardinality
`end_station_name` has a high cardinality: 1725 distinct values	High cardinality
`end_station_id` has a high cardinality: 1323 distinct values	High cardinality
`start_lat` is highly correlated with `start_lng` and 1 other fields	High correlation
`start_lng` is highly correlated with `start_lat` and 1 other fields	High correlation
`end_lat` is highly correlated with `start_lat` and 1 other fields	High correlation
`end_lng` is highly correlated with `start_lng` and 1 other fields	High correlation
`duration_in_mins` is highly correlated with `distance_km`	High correlation
`distance_km` is highly correlated with `duration_in_mins`	High correlation
`start_lat` is highly correlated with `start_lng` and 1 other fields	High correlation
`start_lng` is highly correlated with `start_lat`	High correlation
`end_lat` is highly correlated with `start_lat` and 2 other fields	High correlation
`end_lng` is highly correlated with `end_lat` and 1 other fields	High correlation
`distance_km` is highly correlated with `end_lat` and 1 other fields	High correlation
`start_lat` is highly correlated with `end_lat`	High correlation
`start_lng` is highly correlated with `end_lng`	High correlation
`end_lat` is highly correlated with `start_lat`	High correlation
`end_lng` is highly correlated with `start_lng`	High correlation
`duration_in_mins` is highly correlated with `distance_km`	High correlation
`distance_km` is highly correlated with `duration_in_mins`	High correlation
`start_lat` is highly correlated with `start_lng`	High correlation
`start_lng` is highly correlated with `start_lat`	High correlation
`end_lat` is highly correlated with `end_lng` and 1 other fields	High correlation
`end_lng` is highly correlated with `end_lat` and 1 other fields	High correlation
`distance_km` is highly correlated with `end_lat` and 1 other fields	High correlation
`start_station_name` has 886328 (14.6%) missing values	Missing
`start_station_id` has 886460 (14.6%) missing values	Missing
`end_station_name` has 941355 (15.5%) missing values	Missing
`end_station_id` has 941496 (15.5%) missing values	Missing
`end_lat` is highly skewed (γ1 = -324.798497)	Skewed
`end_lng` is highly skewed (γ1 = 771.2368006)	Skewed
`duration_in_mins` is highly skewed (γ1 = 261.3644865)	Skewed
`distance_km` is highly skewed (γ1 = 835.5510045)	Skewed
`ride_id` is uniformly distributed	Uniform
`started_at` is uniformly distributed	Uniform
`ended_at` is uniformly distributed	Uniform
`ride_id` has unique values	Unique
`duration_in_mins` has 137843 (2.3%) zeros	Zeros
`distance_km` has 328459 (5.4%) zeros	Zeros

Reproduction

Analysis started	2023-04-30 04:45:39.104121
Analysis finished	2023-04-30 04:53:01.413675
Duration	7 minutes and 22.31 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

ride_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	6081641
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

550CF7EFEAE0C618	1
D5D9F57D6DEE6573	1
8EA7198A672FD1BE	1
69FB93A62F116E80	1
870F0ED4E79871E5	1
Other values (6081636)	6081636

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	97306256
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6081641 ?
Unique (%)	100.0%

Sample

1st row	550CF7EFEAE0C618
2nd row	DAD198F405F9C5F5
3rd row	E6F2BC47B65CB7FD
4th row	F597830181C2E13C
5th row	0CE689BB4E313E8D

Common Values

Value	Count	Frequency (%)
550CF7EFEAE0C618	1	< 0.1%
D5D9F57D6DEE6573	1	< 0.1%
8EA7198A672FD1BE	1	< 0.1%
69FB93A62F116E80	1	< 0.1%
870F0ED4E79871E5	1	< 0.1%
DA6B7A72B6FDF93F	1	< 0.1%
3EF916074FFC3585	1	< 0.1%
7EA32BDFB6EEAC01	1	< 0.1%
F4BFA36847700CDC	1	< 0.1%
EA716735F2E3DE70	1	< 0.1%
Other values (6081631)	6081631	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
550cf7efeae0c618	1	< 0.1%
d2f6d8f3feed6874	1	< 0.1%
68c474a4e92f24b6	1	< 0.1%
14a985a3838aa8cc	1	< 0.1%
e724b94bce2e7e36	1	< 0.1%
1aa3756a6f8189db	1	< 0.1%
1749361ac24efb77	1	< 0.1%
cbc1e1c17b07a999	1	< 0.1%
3bbdd414f3f543ce	1	< 0.1%
1edac7624ba69c98	1	< 0.1%
Other values (6081631)	6081631	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	6084749	6.3%
D	6084627	6.3%
B	6084436	6.3%
9	6083751	6.3%
3	6082816	6.3%
2	6082576	6.3%
C	6082564	6.3%
6	6081493	6.2%
5	6080971	6.2%
0	6080899	6.2%
Other values (6)	36477374	37.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	60809563	62.5%
Uppercase Letter	36496693	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	6083751	10.0%
3	6082816	10.0%
2	6082576	10.0%
6	6081493	10.0%
5	6080971	10.0%
0	6080899	10.0%
7	6080752	10.0%
8	6079863	10.0%
1	6079159	10.0%
4	6077283	10.0%

Uppercase Letter

Value	Count	Frequency (%)
A	6084749	16.7%
D	6084627	16.7%
B	6084436	16.7%
C	6082564	16.7%
F	6080899	16.7%
E	6079418	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	60809563	62.5%
Latin	36496693	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	6083751	10.0%
3	6082816	10.0%
2	6082576	10.0%
6	6081493	10.0%
5	6080971	10.0%
0	6080899	10.0%
7	6080752	10.0%
8	6079863	10.0%
1	6079159	10.0%
4	6077283	10.0%

Latin

Value	Count	Frequency (%)
A	6084749	16.7%
D	6084627	16.7%
B	6084436	16.7%
C	6082564	16.7%
F	6080899	16.7%
E	6079418	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	97306256	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	6084749	6.3%
D	6084627	6.3%
B	6084436	6.3%
9	6083751	6.3%
3	6082816	6.3%
2	6082576	6.3%
C	6082564	6.3%
6	6081493	6.2%
5	6080971	6.2%
0	6080899	6.2%
Other values (6)	36477374	37.5%

rideable_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

electric_bike	3131659
classic_bike	2770634
docked_bike	179348

Length

Max length	13
Median length	13
Mean length	12.48544644
Min length	11

Characters and Unicode

Total characters	75932003
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	electric_bike
2nd row	electric_bike
3rd row	electric_bike
4th row	electric_bike
5th row	electric_bike

Common Values

Value	Count	Frequency (%)
electric_bike	3131659	51.5%
classic_bike	2770634	45.6%
docked_bike	179348	2.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
electric_bike	3131659	51.5%
classic_bike	2770634	45.6%
docked_bike	179348	2.9%

Most occurring characters

Value	Count	Frequency (%)
e	12524307	16.5%
c	11983934	15.8%
i	11983934	15.8%
k	6260989	8.2%
_	6081641	8.0%
b	6081641	8.0%
l	5902293	7.8%
s	5541268	7.3%
t	3131659	4.1%
r	3131659	4.1%
Other values (3)	3308678	4.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	69850362	92.0%
Connector Punctuation	6081641	8.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12524307	17.9%
c	11983934	17.2%
i	11983934	17.2%
k	6260989	9.0%
b	6081641	8.7%
l	5902293	8.4%
s	5541268	7.9%
t	3131659	4.5%
r	3131659	4.5%
a	2770634	4.0%
Other values (2)	538044	0.8%

Connector Punctuation

Value	Count	Frequency (%)
_	6081641	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	69850362	92.0%
Common	6081641	8.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12524307	17.9%
c	11983934	17.2%
i	11983934	17.2%
k	6260989	9.0%
b	6081641	8.7%
l	5902293	8.4%
s	5541268	7.9%
t	3131659	4.5%
r	3131659	4.5%
a	2770634	4.0%
Other values (2)	538044	0.8%

Common

Value	Count	Frequency (%)
_	6081641	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	75932003	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12524307	16.5%
c	11983934	15.8%
i	11983934	15.8%
k	6260989	8.2%
_	6081641	8.0%
b	6081641	8.0%
l	5902293	7.8%
s	5541268	7.3%
t	3131659	4.1%
r	3131659	4.1%
Other values (3)	3308678	4.4%

started_at
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	5125092
Distinct (%)	84.3%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

2022-05-30 13:05:15	9
2022-07-09 17:23:31	8
2022-10-24 16:59:45	8
2022-10-03 17:22:27	8
2022-08-10 17:25:13	7
Other values (5125087)	6081601

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	115551179
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4310611 ?
Unique (%)	70.9%

Sample

1st row	2022-08-07 21:34:15
2nd row	2022-08-08 14:39:21
3rd row	2022-08-08 15:29:50
4th row	2022-08-08 02:43:50
5th row	2022-08-07 20:24:06

Common Values

Value	Count	Frequency (%)
2022-05-30 13:05:15	9	< 0.1%
2022-07-09 17:23:31	8	< 0.1%
2022-10-24 16:59:45	8	< 0.1%
2022-10-03 17:22:27	8	< 0.1%
2022-08-10 17:25:13	7	< 0.1%
2022-07-27 17:05:02	7	< 0.1%
2022-05-29 12:56:58	7	< 0.1%
2022-06-02 18:25:07	7	< 0.1%
2022-09-03 11:43:56	7	< 0.1%
2022-07-14 17:49:58	7	< 0.1%
Other values (5125082)	6081566	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-07-09	36104	0.3%
2022-04-23	34893	0.3%
2022-06-18	34255	0.3%
2022-05-29	33324	0.3%
2022-07-30	33288	0.3%
2022-06-26	32925	0.3%
2022-07-16	32507	0.3%
2022-06-11	32474	0.3%
2022-08-27	32172	0.3%
2022-05-28	31885	0.3%
Other values (86743)	11829455	97.3%

Most occurring characters

Value	Count	Frequency (%)
2	25163436	21.8%
0	19070578	16.5%
1	12275204	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5871259	5.1%
5	4894748	4.2%
4	4614811	4.0%
7	3465837	3.0%
Other values (3)	9787101	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	85142974	73.7%
Dash Punctuation	12163282	10.5%
Other Punctuation	12163282	10.5%
Space Separator	6081641	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	25163436	29.6%
0	19070578	22.4%
1	12275204	14.4%
3	5871259	6.9%
5	4894748	5.7%
4	4614811	5.4%
7	3465837	4.1%
8	3388201	4.0%
6	3234004	3.8%
9	3164896	3.7%

Dash Punctuation

Value	Count	Frequency (%)
-	12163282	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	12163282	100.0%

Space Separator

Value	Count	Frequency (%)
	6081641	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115551179	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	25163436	21.8%
0	19070578	16.5%
1	12275204	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5871259	5.1%
5	4894748	4.2%
4	4614811	4.0%
7	3465837	3.0%
Other values (3)	9787101	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115551179	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	25163436	21.8%
0	19070578	16.5%
1	12275204	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5871259	5.1%
5	4894748	4.2%
4	4614811	4.0%
7	3465837	3.0%
Other values (3)	9787101	8.5%

ended_at
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	5138667
Distinct (%)	84.5%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

2022-08-22 12:47:49	20
2022-06-22 08:01:59	14
2022-06-07 16:12:09	11
2023-03-22 17:30:49	11
2023-03-21 16:59:40	10
Other values (5138662)	6081575

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	115551179
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4331896 ?
Unique (%)	71.2%

Sample

1st row	2022-08-07 21:41:46
2nd row	2022-08-08 14:53:23
3rd row	2022-08-08 15:40:34
4th row	2022-08-08 02:58:53
5th row	2022-08-07 20:29:58

Common Values

Value	Count	Frequency (%)
2022-08-22 12:47:49	20	< 0.1%
2022-06-22 08:01:59	14	< 0.1%
2022-06-07 16:12:09	11	< 0.1%
2023-03-22 17:30:49	11	< 0.1%
2023-03-21 16:59:40	10	< 0.1%
2022-08-19 15:02:42	9	< 0.1%
2022-08-22 12:47:50	9	< 0.1%
2022-09-06 17:51:39	8	< 0.1%
2022-06-03 17:34:16	8	< 0.1%
2022-08-19 16:21:17	8	< 0.1%
Other values (5138657)	6081533	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-07-09	36010	0.3%
2022-04-23	34575	0.3%
2022-06-18	34283	0.3%
2022-05-29	33300	0.3%
2022-07-30	33245	0.3%
2022-06-26	33214	0.3%
2022-06-11	32386	0.3%
2022-07-16	32348	0.3%
2022-08-27	32041	0.3%
2022-09-10	31849	0.3%
Other values (86742)	11830031	97.3%

Most occurring characters

Value	Count	Frequency (%)
2	25238570	21.8%
0	19067520	16.5%
1	12207979	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5872180	5.1%
5	4919220	4.3%
4	4586264	4.0%
7	3442878	3.0%
Other values (3)	9808363	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	85142974	73.7%
Dash Punctuation	12163282	10.5%
Other Punctuation	12163282	10.5%
Space Separator	6081641	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	25238570	29.6%
0	19067520	22.4%
1	12207979	14.3%
3	5872180	6.9%
5	4919220	5.8%
4	4586264	5.4%
7	3442878	4.0%
8	3416344	4.0%
9	3198918	3.8%
6	3193101	3.8%

Dash Punctuation

Value	Count	Frequency (%)
-	12163282	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	12163282	100.0%

Space Separator

Value	Count	Frequency (%)
	6081641	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115551179	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	25238570	21.8%
0	19067520	16.5%
1	12207979	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5872180	5.1%
5	4919220	4.3%
4	4586264	4.0%
7	3442878	3.0%
Other values (3)	9808363	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115551179	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	25238570	21.8%
0	19067520	16.5%
1	12207979	10.6%
-	12163282	10.5%
:	12163282	10.5%
	6081641	5.3%
3	5872180	5.1%
5	4919220	4.3%
4	4586264	4.0%
7	3442878	3.0%
Other values (3)	9808363	8.5%

start_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct	1702
Distinct (%)	< 0.1%
Missing	886328
Missing (%)	14.6%
Memory size	46.4 MiB

Streeter Dr & Grand Ave	77051
DuSable Lake Shore Dr & Monroe St	42405
Michigan Ave & Oak St	40848
DuSable Lake Shore Dr & North Blvd	40810
Wells St & Concord Ln	39990
Other values (1697)	4954209

Length

Max length	64
Median length	50
Mean length	23.91537218
Min length	7

Characters and Unicode

Total characters	124247844
Distinct characters	72
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	111 ?
Unique (%)	< 0.1%

Sample

1st row	DuSable Museum
2nd row	Robert Fulton Elementary School
3rd row	California Ave & Milwaukee Ave
4th row	Campbell Ave & Montrose Ave
5th row	California Ave & Division St

Common Values

Value	Count	Frequency (%)
Streeter Dr & Grand Ave	77051	1.3%
DuSable Lake Shore Dr & Monroe St	42405	0.7%
Michigan Ave & Oak St	40848	0.7%
DuSable Lake Shore Dr & North Blvd	40810	0.7%
Wells St & Concord Ln	39990	0.7%
Clark St & Elm St	37805	0.6%
Kingsbury St & Kinzie St	36412	0.6%
Millennium Park	36298	0.6%
Wells St & Elm St	33843	0.6%
Theater on the Lake	33702	0.6%
Other values (1692)	4776149	78.5%
(Missing)	886328	14.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	4936954	18.9%
st	4552158	17.4%
ave	3673605	14.1%
dr	379865	1.5%
clark	378874	1.4%
lake	334908	1.3%
blvd	312073	1.2%
rd	264340	1.0%
wells	202036	0.8%
park	192172	0.7%
Other values (775)	10906111	41.7%

Most occurring characters

Value	Count	Frequency (%)
	20938019	16.9%
e	10763904	8.7%
t	8122379	6.5%
a	6916077	5.6%
r	5934353	4.8%
n	5806928	4.7%
S	5758029	4.6%
l	5365248	4.3%
o	5151405	4.1%
&	4907807	4.0%
Other values (62)	44583695	35.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	76211229	61.3%
Space Separator	20938019	16.9%
Uppercase Letter	20905377	16.8%
Other Punctuation	4983328	4.0%
Decimal Number	994491	0.8%
Open Punctuation	92983	0.1%
Close Punctuation	92983	0.1%
Dash Punctuation	29434	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10763904	14.1%
t	8122379	10.7%
a	6916077	9.1%
r	5934353	7.8%
n	5806928	7.6%
l	5365248	7.0%
o	5151405	6.8%
v	4716835	6.2%
i	4378690	5.7%
d	2899451	3.8%
Other values (16)	16155959	21.2%

Uppercase Letter

Value	Count	Frequency (%)
S	5758029	27.5%
A	4136147	19.8%
C	1429846	6.8%
W	1277451	6.1%
D	1119317	5.4%
L	948692	4.5%
M	887762	4.2%
B	885771	4.2%
P	791186	3.8%
R	786337	3.8%
Other values (16)	2884839	13.8%

Decimal Number

Value	Count	Frequency (%)
5	217034	21.8%
3	168381	16.9%
1	162035	16.3%
8	96490	9.7%
9	69314	7.0%
6	65720	6.6%
0	62352	6.3%
7	55243	5.6%
2	52809	5.3%
4	45113	4.5%

Other Punctuation

Value	Count	Frequency (%)
&	4907807	98.5%
*	43119	0.9%
.	31592	0.6%
/	801	< 0.1%
"	6	< 0.1%
;	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	20938019	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	92983	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	92983	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	97116606	78.2%
Common	27131238	21.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10763904	11.1%
t	8122379	8.4%
a	6916077	7.1%
r	5934353	6.1%
n	5806928	6.0%
S	5758029	5.9%
l	5365248	5.5%
o	5151405	5.3%
v	4716835	4.9%
i	4378690	4.5%
Other values (42)	34202758	35.2%

Common

Value	Count	Frequency (%)
	20938019	77.2%
&	4907807	18.1%
5	217034	0.8%
3	168381	0.6%
1	162035	0.6%
8	96490	0.4%
(	92983	0.3%
)	92983	0.3%
9	69314	0.3%
6	65720	0.2%
Other values (10)	320472	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	124247844	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	20938019	16.9%
e	10763904	8.7%
t	8122379	6.5%
a	6916077	5.6%
r	5934353	4.8%
n	5806928	4.7%
S	5758029	4.6%
l	5365248	4.3%
o	5151405	4.1%
&	4907807	4.0%
Other values (62)	44583695	35.9%

start_station_id
Categorical

HIGH CARDINALITY
MISSING

Distinct	1318
Distinct (%)	< 0.1%
Missing	886460
Missing (%)	14.6%
Memory size	46.4 MiB

13022	77051
13300	42405
13042	40848
LF-005	40810
TA1308000050	39990
Other values (1313)	4954077

Length

Max length	37
Median length	36
Mean length	8.416704827
Min length	3

Characters and Unicode

Total characters	43726305
Distinct characters	58
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39 ?
Unique (%)	< 0.1%

Sample

1st row	KA1503000075
2nd row	819
3rd row	13084
4th row	15623
5th row	13256

Common Values

Value	Count	Frequency (%)
13022	77051	1.3%
13300	42405	0.7%
13042	40848	0.7%
LF-005	40810	0.7%
TA1308000050	39990	0.7%
TA1307000039	37805	0.6%
KA1503000043	36412	0.6%
13008	36298	0.6%
KA1504000135	33843	0.6%
TA1308000001	33702	0.6%
Other values (1308)	4776017	78.5%
(Missing)	886460	14.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
13022	77051	1.5%
13300	42405	0.8%
13042	40848	0.8%
lf-005	40810	0.8%
ta1308000050	39990	0.8%
ta1307000039	37805	0.7%
ka1503000043	36412	0.7%
13008	36298	0.7%
ka1504000135	33843	0.7%
ta1308000001	33702	0.6%
Other values (1325)	4780531	91.9%

Most occurring characters

Value	Count	Frequency (%)
0	14161433	32.4%
1	7005928	16.0%
3	5579234	12.8%
A	2529047	5.8%
5	2368241	5.4%
T	2008835	4.6%
2	1805677	4.1%
4	1541706	3.5%
6	1476587	3.4%
7	1357654	3.1%
Other values (48)	3891963	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37352600	85.4%
Uppercase Letter	5583724	12.8%
Lowercase Letter	510636	1.2%
Dash Punctuation	236376	0.5%
Other Punctuation	34587	0.1%
Space Separator	4514	< 0.1%
Close Punctuation	1934	< 0.1%
Open Punctuation	1934	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2529047	45.3%
T	2008835	36.0%
K	537582	9.6%
L	202339	3.6%
S	102368	1.8%
W	50115	0.9%
P	41760	0.7%
F	40810	0.7%
R	30117	0.5%
N	15103	0.3%
Other values (11)	25648	0.5%

Lowercase Letter

Value	Count	Frequency (%)
g	88369	17.3%
i	47327	9.3%
c	46999	9.2%
a	45478	8.9%
n	45326	8.9%
r	45239	8.9%
h	45215	8.9%
t	43540	8.5%
s	43520	8.5%
x	43119	8.4%
Other values (11)	16504	3.2%

Decimal Number

Value	Count	Frequency (%)
0	14161433	37.9%
1	7005928	18.8%
3	5579234	14.9%
5	2368241	6.3%
2	1805677	4.8%
4	1541706	4.1%
6	1476587	4.0%
7	1357654	3.6%
9	1235770	3.3%
8	820370	2.2%

Other Punctuation

Value	Count	Frequency (%)
.	34551	99.9%
&	36	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	236376	100.0%

Space Separator

Value	Count	Frequency (%)
	4514	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1934	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1934	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	37631945	86.1%
Latin	6094360	13.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2529047	41.5%
T	2008835	33.0%
K	537582	8.8%
L	202339	3.3%
S	102368	1.7%
g	88369	1.5%
W	50115	0.8%
i	47327	0.8%
c	46999	0.8%
a	45478	0.7%
Other values (32)	435901	7.2%

Common

Value	Count	Frequency (%)
0	14161433	37.6%
1	7005928	18.6%
3	5579234	14.8%
5	2368241	6.3%
2	1805677	4.8%
4	1541706	4.1%
6	1476587	3.9%
7	1357654	3.6%
9	1235770	3.3%
8	820370	2.2%
Other values (6)	279345	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43726305	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14161433	32.4%
1	7005928	16.0%
3	5579234	12.8%
A	2529047	5.8%
5	2368241	5.4%
T	2008835	4.6%
2	1805677	4.1%
4	1541706	3.5%
6	1476587	3.4%
7	1357654	3.1%
Other values (48)	3891963	8.9%

end_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct	1725
Distinct (%)	< 0.1%
Missing	941355
Missing (%)	15.5%
Memory size	46.4 MiB

Streeter Dr & Grand Ave	77569
DuSable Lake Shore Dr & North Blvd	42978
Michigan Ave & Oak St	41397
DuSable Lake Shore Dr & Monroe St	41168
Wells St & Concord Ln	40053
Other values (1720)	4897121

Length

Max length	64
Median length	50
Mean length	23.92562301
Min length	9

Characters and Unicode

Total characters	122984545
Distinct characters	71
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	129 ?
Unique (%)	< 0.1%

Sample

1st row	Western Ave & Roscoe St
2nd row	Western Ave & 105th St
3rd row	Cottage Grove Ave & 51st St
4th row	Campbell Ave & Montrose Ave
5th row	California Ave & Milwaukee Ave

Common Values

Value	Count	Frequency (%)
Streeter Dr & Grand Ave	77569	1.3%
DuSable Lake Shore Dr & North Blvd	42978	0.7%
Michigan Ave & Oak St	41397	0.7%
DuSable Lake Shore Dr & Monroe St	41168	0.7%
Wells St & Concord Ln	40053	0.7%
Clark St & Elm St	37216	0.6%
Millennium Park	36787	0.6%
Kingsbury St & Kinzie St	35217	0.6%
Theater on the Lake	33844	0.6%
Wells St & Elm St	32767	0.5%
Other values (1715)	4721290	77.6%
(Missing)	941355	15.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	4889402	18.9%
st	4491116	17.4%
ave	3667362	14.2%
clark	374302	1.4%
dr	373823	1.4%
lake	335533	1.3%
blvd	307603	1.2%
rd	261072	1.0%
wells	193303	0.7%
park	189759	0.7%
Other values (777)	10773964	41.7%

Most occurring characters

Value	Count	Frequency (%)
	20717213	16.8%
e	10701986	8.7%
t	8029001	6.5%
a	6832163	5.6%
r	5871803	4.8%
n	5746719	4.7%
S	5691320	4.6%
l	5309195	4.3%
o	5113172	4.2%
&	4861467	4.0%
Other values (61)	44110506	35.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	75461147	61.4%
Space Separator	20717213	16.8%
Uppercase Letter	20680332	16.8%
Other Punctuation	4940441	4.0%
Decimal Number	974994	0.8%
Close Punctuation	91141	0.1%
Open Punctuation	91141	0.1%
Dash Punctuation	28136	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10701986	14.2%
t	8029001	10.6%
a	6832163	9.1%
r	5871803	7.8%
n	5746719	7.6%
l	5309195	7.0%
o	5113172	6.8%
v	4701198	6.2%
i	4330332	5.7%
d	2867629	3.8%
Other values (16)	15957949	21.1%

Uppercase Letter

Value	Count	Frequency (%)
S	5691320	27.5%
A	4122411	19.9%
C	1413570	6.8%
W	1255349	6.1%
D	1109389	5.4%
L	945821	4.6%
M	878274	4.2%
B	876836	4.2%
R	780881	3.8%
P	773865	3.7%
Other values (16)	2832616	13.7%

Decimal Number

Value	Count	Frequency (%)
5	214224	22.0%
3	166676	17.1%
1	159632	16.4%
8	94672	9.7%
9	66882	6.9%
6	64091	6.6%
0	60322	6.2%
7	54873	5.6%
2	49302	5.1%
4	44320	4.5%

Other Punctuation

Value	Count	Frequency (%)
&	4861467	98.4%
*	45957	0.9%
.	32295	0.7%
/	712	< 0.1%
"	10	< 0.1%

Space Separator

Value	Count	Frequency (%)
	20717213	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	91141	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	91141	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	28136	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	96141479	78.2%
Common	26843066	21.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10701986	11.1%
t	8029001	8.4%
a	6832163	7.1%
r	5871803	6.1%
n	5746719	6.0%
S	5691320	5.9%
l	5309195	5.5%
o	5113172	5.3%
v	4701198	4.9%
i	4330332	4.5%
Other values (42)	33814590	35.2%

Common

Value	Count	Frequency (%)
	20717213	77.2%
&	4861467	18.1%
5	214224	0.8%
3	166676	0.6%
1	159632	0.6%
8	94672	0.4%
)	91141	0.3%
(	91141	0.3%
9	66882	0.2%
6	64091	0.2%
Other values (9)	315927	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	122984545	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	20717213	16.8%
e	10701986	8.7%
t	8029001	6.5%
a	6832163	5.6%
r	5871803	4.8%
n	5746719	4.7%
S	5691320	4.6%
l	5309195	4.3%
o	5113172	4.2%
&	4861467	4.0%
Other values (61)	44110506	35.9%

end_station_id
Categorical

HIGH CARDINALITY
MISSING

Distinct	1323
Distinct (%)	< 0.1%
Missing	941496
Missing (%)	15.5%
Memory size	46.4 MiB

13022	77569
LF-005	42978
13042	41397
13300	41168
TA1308000050	40053
Other values (1318)	4896980

Length

Max length	37
Median length	36
Mean length	8.422088482
Min length	3

Characters and Unicode

Total characters	43290756
Distinct characters	58
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	< 0.1%

Sample

1st row	15634
2nd row	691
3rd row	TA1309000067
4th row	15623
5th row	13084

Common Values

Value	Count	Frequency (%)
13022	77569	1.3%
LF-005	42978	0.7%
13042	41397	0.7%
13300	41168	0.7%
TA1308000050	40053	0.7%
TA1307000039	37216	0.6%
13008	36787	0.6%
KA1503000043	35217	0.6%
TA1308000001	33844	0.6%
KA1504000135	32767	0.5%
Other values (1313)	4721149	77.6%
(Missing)	941496	15.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
13022	77569	1.5%
lf-005	42978	0.8%
13042	41397	0.8%
13300	41168	0.8%
ta1308000050	40053	0.8%
ta1307000039	37216	0.7%
13008	36787	0.7%
ka1503000043	35217	0.7%
ta1308000001	33844	0.7%
ka1504000135	32767	0.6%
Other values (1330)	4721953	91.8%

Most occurring characters

Value	Count	Frequency (%)
0	14029638	32.4%
1	6956014	16.1%
3	5524161	12.8%
A	2509406	5.8%
5	2352498	5.4%
T	1989789	4.6%
2	1773498	4.1%
4	1528660	3.5%
6	1454611	3.4%
7	1344389	3.1%
Other values (48)	3828092	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37004902	85.5%
Uppercase Letter	5516043	12.7%
Lowercase Letter	510766	1.2%
Dash Punctuation	227455	0.5%
Other Punctuation	30336	0.1%
Space Separator	804	< 0.1%
Close Punctuation	225	< 0.1%
Open Punctuation	225	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2509406	45.5%
T	1989789	36.1%
K	532678	9.7%
L	196907	3.6%
S	93108	1.7%
W	48502	0.9%
F	42978	0.8%
P	40699	0.7%
R	30063	0.5%
N	14882	0.3%
Other values (11)	17031	0.3%

Lowercase Letter

Value	Count	Frequency (%)
g	92247	18.1%
i	46558	9.1%
c	46427	9.1%
a	46320	9.1%
r	46268	9.1%
n	46258	9.1%
h	46248	9.1%
t	46059	9.0%
s	46042	9.0%
x	45959	9.0%
Other values (11)	2380	0.5%

Decimal Number

Value	Count	Frequency (%)
0	14029638	37.9%
1	6956014	18.8%
3	5524161	14.9%
5	2352498	6.4%
2	1773498	4.8%
4	1528660	4.1%
6	1454611	3.9%
7	1344389	3.6%
9	1224906	3.3%
8	816527	2.2%

Other Punctuation

Value	Count	Frequency (%)
.	30298	99.9%
&	38	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	227455	100.0%

Space Separator

Value	Count	Frequency (%)
	804	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	225	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	225	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	37263947	86.1%
Latin	6026809	13.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2509406	41.6%
T	1989789	33.0%
K	532678	8.8%
L	196907	3.3%
S	93108	1.5%
g	92247	1.5%
W	48502	0.8%
i	46558	0.8%
c	46427	0.8%
a	46320	0.8%
Other values (32)	424867	7.0%

Common

Value	Count	Frequency (%)
0	14029638	37.6%
1	6956014	18.7%
3	5524161	14.8%
5	2352498	6.3%
2	1773498	4.8%
4	1528660	4.1%
6	1454611	3.9%
7	1344389	3.6%
9	1224906	3.3%
8	816527	2.2%
Other values (6)	259045	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43290756	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14029638	32.4%
1	6956014	16.1%
3	5524161	12.8%
A	2509406	5.8%
5	2352498	5.4%
T	1989789	4.6%
2	1773498	4.1%
4	1528660	3.5%
6	1454611	3.4%
7	1344389	3.1%
Other values (48)	3828092	8.8%

start_lat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	722564
Distinct (%)	11.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.90206158

Minimum	41.64
Maximum	42.07
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 MiB

Quantile statistics

Minimum	41.64
5-th percentile	41.8
Q1	41.88096617
median	41.89993001
Q3	41.93
95-th percentile	41.97
Maximum	42.07
Range	0.43
Interquartile range (IQR)	0.04903383333

Descriptive statistics

Standard deviation	0.0462265043
Coefficient of variation (CV)	0.001103203579
Kurtosis	2.14375908
Mean	41.90206158
Median Absolute Deviation (MAD)	0.02274901
Skewness	-0.4768937608
Sum	254833295.7
Variance	0.0021368897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.93	99695	1.6%
41.89	95050	1.6%
41.92	92209	1.5%
41.94	83274	1.4%
41.91	81587	1.3%
41.9	73058	1.2%
41.88	64844	1.1%
41.95	63830	1.0%
41.892278	53873	0.9%
41.79	47505	0.8%
Other values (722554)	5326716	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.64	3	< 0.1%
41.64850076	85	< 0.1%
41.648501	8	< 0.1%
41.64853067	1	< 0.1%
41.64854717	1	< 0.1%
41.648552	1	< 0.1%
41.64855417	1	< 0.1%
41.64855483	1	< 0.1%
41.64855783	1	< 0.1%
41.64855945	1	< 0.1%

Value	Count	Frequency (%)
42.07	305	< 0.1%
42.06486917	1	< 0.1%
42.06485633	1	< 0.1%
42.064854	350	< 0.1%
42.06485033	1	< 0.1%
42.0648435	1	< 0.1%
42.0648425	1	< 0.1%
42.06483996	1	< 0.1%
42.06483767	1	< 0.1%
42.06482833	1	< 0.1%

start_lng
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	682475
Distinct (%)	11.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.64779682

Minimum	-87.84
Maximum	-87.52
Zeros	0
Zeros (%)	0.0%
Negative	6081641
Negative (%)	100.0%
Memory size	46.4 MiB

Quantile statistics

Minimum	-87.84
5-th percentile	-87.7
Q1	-87.661501
median	-87.64410555
Q3	-87.629634
95-th percentile	-87.607267
Maximum	-87.52
Range	0.32
Interquartile range (IQR)	0.031867

Descriptive statistics

Standard deviation	0.02920161611
Coefficient of variation (CV)	-0.0003331699959
Kurtosis	2.910488901
Mean	-87.64779682
Median Absolute Deviation (MAD)	0.015894446
Skewness	-0.9905368322
Sum	-533042434.7
Variance	0.0008527343832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.65	138302	2.3%
-87.63	103546	1.7%
-87.64	91466	1.5%
-87.66	84833	1.4%
-87.67	73781	1.2%
-87.69	68184	1.1%
-87.68	63469	1.0%
-87.7	59692	1.0%
-87.612043	53859	0.9%
-87.62	51929	0.9%
Other values (682465)	5292580	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.84	22	< 0.1%
-87.8333205	1	< 0.1%
-87.8333085	1	< 0.1%
-87.8332685	1	< 0.1%
-87.83325417	1	< 0.1%
-87.83324883	1	< 0.1%
-87.83323517	1	< 0.1%
-87.83322867	1	< 0.1%
-87.83	675	< 0.1%
-87.8293115	1	< 0.1%

Value	Count	Frequency (%)
-87.52	30	< 0.1%
-87.525314	1	< 0.1%
-87.52823174	142	< 0.1%
-87.528232	28	< 0.1%
-87.52833083	1	< 0.1%
-87.528355	1	< 0.1%
-87.52836583	1	< 0.1%
-87.52837	1	< 0.1%
-87.52837083	1	< 0.1%
-87.52838033	1	< 0.1%

end_lat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1634
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.9022444

Minimum	0
Maximum	42.37
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 MiB

Quantile statistics

Minimum	0
5-th percentile	41.8
Q1	41.8810317
median	41.9
Q3	41.93
95-th percentile	41.97
Maximum	42.37
Range	42.37
Interquartile range (IQR)	0.0489683

Descriptive statistics

Standard deviation	0.06680262885
Coefficient of variation (CV)	0.001594249421
Kurtosis	203629.5423
Mean	41.9022444
Median Absolute Deviation (MAD)	0.022819
Skewness	-324.798497
Sum	254834407.5
Variance	0.004462591221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.93	101809	1.7%
41.89	101481	1.7%
41.92	94602	1.6%
41.91	85113	1.4%
41.94	84475	1.4%
41.892278	77550	1.3%
41.9	76158	1.3%
41.88	70296	1.2%
41.95	65069	1.1%
41.79	48395	0.8%
Other values (1624)	5276693	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
41.55	4	< 0.1%
41.59	1	< 0.1%
41.6	2	< 0.1%
41.61	1	< 0.1%
41.62	3	< 0.1%
41.63	5	< 0.1%
41.64	11	< 0.1%
41.64850076	89	< 0.1%
41.648501	4	< 0.1%

Value	Count	Frequency (%)
42.37	1	< 0.1%
42.19	2	< 0.1%
42.15	1	< 0.1%
42.13	2	< 0.1%
42.12	2	< 0.1%
42.11	5	< 0.1%
42.1	2	< 0.1%
42.09	3	< 0.1%
42.08	41	< 0.1%
42.07	385	< 0.1%

end_lng
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1619
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.64786739

Minimum	-88.14
Maximum	0
Zeros	8
Zeros (%)	< 0.1%
Negative	6081633
Negative (%)	> 99.9%
Memory size	46.4 MiB

Quantile statistics

Minimum	-88.14
5-th percentile	-87.7
Q1	-87.662007
median	-87.64414
Q3	-87.62974631
95-th percentile	-87.607267
Maximum	0
Range	88.14
Interquartile range (IQR)	0.0322606948

Descriptive statistics

Standard deviation	0.1047203596
Coefficient of variation (CV)	-0.001194785027
Kurtosis	645518.4026
Mean	-87.64786739
Median Absolute Deviation (MAD)	0.01586
Skewness	771.2368006
Sum	-533042863.9
Variance	0.01096635371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.65	143424	2.4%
-87.63	111969	1.8%
-87.64	96507	1.6%
-87.66	88477	1.5%
-87.612043	77550	1.3%
-87.67	77432	1.3%
-87.69	68840	1.1%
-87.68	65148	1.1%
-87.7	59483	1.0%
-87.62	57626	0.9%
Other values (1609)	5235185	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-88.14	1	< 0.1%
-88.05	1	< 0.1%
-87.93	1	< 0.1%
-87.92	4	< 0.1%
-87.9	1	< 0.1%
-87.89	3	< 0.1%
-87.88	4	< 0.1%
-87.87	3	< 0.1%
-87.86	8	< 0.1%
-87.85	7	< 0.1%

Value	Count	Frequency (%)
0	8	< 0.1%
-87.3	4	< 0.1%
-87.5	1	< 0.1%
-87.51	6	< 0.1%
-87.52	52	< 0.1%
-87.52823174	223	< 0.1%
-87.528232	30	< 0.1%
-87.52845117	1	< 0.1%
-87.53	332	< 0.1%
-87.530431	90	< 0.1%

member_casual
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

member	3659726
casual	2421915

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	36489846
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	casual
2nd row	casual
3rd row	casual
4th row	casual
5th row	casual

Common Values

Value	Count	Frequency (%)
member	3659726	60.2%
casual	2421915	39.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
member	3659726	60.2%
casual	2421915	39.8%

Most occurring characters

Value	Count	Frequency (%)
m	7319452	20.1%
e	7319452	20.1%
a	4843830	13.3%
b	3659726	10.0%
r	3659726	10.0%
c	2421915	6.6%
s	2421915	6.6%
u	2421915	6.6%
l	2421915	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	36489846	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	7319452	20.1%
e	7319452	20.1%
a	4843830	13.3%
b	3659726	10.0%
r	3659726	10.0%
c	2421915	6.6%
s	2421915	6.6%
u	2421915	6.6%
l	2421915	6.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	36489846	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	7319452	20.1%
e	7319452	20.1%
a	4843830	13.3%
b	3659726	10.0%
r	3659726	10.0%
c	2421915	6.6%
s	2421915	6.6%
u	2421915	6.6%
l	2421915	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36489846	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	7319452	20.1%
e	7319452	20.1%
a	4843830	13.3%
b	3659726	10.0%
r	3659726	10.0%
c	2421915	6.6%
s	2421915	6.6%
u	2421915	6.6%
l	2421915	6.6%

duration_in_mins
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	1495
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.41898691

Minimum	-10354
Maximum	34354
Zeros	137843
Zeros (%)	2.3%
Negative	101
Negative (%)	< 0.1%
Memory size	46.4 MiB

Quantile statistics

Minimum	-10354
5-th percentile	2
Q1	5
median	10
Q3	17
95-th percentile	43
Maximum	34354
Range	44708
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	37.75881048
Coefficient of variation (CV)	2.448851581
Kurtosis	207129.8497
Mean	15.41898691
Median Absolute Deviation (MAD)	5
Skewness	261.3644865
Sum	93772743
Variance	1425.727769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	404947	6.7%
4	402503	6.6%
6	387523	6.4%
7	361315	5.9%
3	354935	5.8%
8	331728	5.5%
9	302725	5.0%
10	273087	4.5%
11	242918	4.0%
2	241929	4.0%
Other values (1485)	2778031	45.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10354	1	< 0.1%
-169	1	< 0.1%
-138	1	< 0.1%
-131	1	< 0.1%
-130	1	< 0.1%
-128	1	< 0.1%
-127	1	< 0.1%
-126	1	< 0.1%
-118	1	< 0.1%
-102	1	< 0.1%

Value	Count	Frequency (%)
34354	1	< 0.1%
32035	1	< 0.1%
13928	1	< 0.1%
10807	1	< 0.1%
10722	1	< 0.1%
10126	1	< 0.1%
9962	1	< 0.1%
8755	1	< 0.1%
8243	1	< 0.1%
7545	1	< 0.1%

distance_km
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	114173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.11474072

Minimum	0
Maximum	9814.083
Zeros	328459
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	46.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.865
median	1.552
Q3	2.7543
95-th percentile	5.8655
Maximum	9814.083
Range	9814.083
Interquartile range (IQR)	1.8893

Descriptive statistics

Standard deviation	11.41293769
Coefficient of variation (CV)	5.396849638
Kurtosis	718233.5981
Mean	2.11474072
Median Absolute Deviation (MAD)	0.8269
Skewness	835.5510045
Sum	12861093.87
Variance	130.2551467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	328459	5.4%
1.112	60088	1.0%
2.2239	16388	0.3%
0.7166	13431	0.2%
1.0239	12274	0.2%
1.386	12191	0.2%
1.387	11299	0.2%
0.8272	7393	0.1%
1.3175	7237	0.1%
0.8291	6832	0.1%
Other values (114163)	5606049	92.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	328459	5.4%
0.0001	28	< 0.1%
0.0002	48	< 0.1%
0.0003	78	< 0.1%
0.0004	124	< 0.1%
0.0005	112	< 0.1%
0.0006	159	< 0.1%
0.0007	182	< 0.1%
0.0008	193	< 0.1%
0.0009	227	< 0.1%

Value	Count	Frequency (%)
9814.083	1	< 0.1%
9813.3911	1	< 0.1%
9813.0858	1	< 0.1%
9812.9313	1	< 0.1%
9812.9299	1	< 0.1%
9812.1879	1	< 0.1%
9811.8243	1	< 0.1%
9811.5246	1	< 0.1%
42.2722	1	< 0.1%
37.6787	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	ride_id	rideable_type	started_at	ended_at	start_station_name	start_station_id	end_station_name	end_station_id	start_lat	start_lng	end_lat	end_lng	member_casual	duration_in_mins	distance_km
0	550CF7EFEAE0C618	electric_bike	2022-08-07 21:34:15	2022-08-07 21:41:46	NaN	NaN	NaN	NaN	41.93	-87.69	41.94	-87.72	casual	7.0	2.7193
1	DAD198F405F9C5F5	electric_bike	2022-08-08 14:39:21	2022-08-08 14:53:23	NaN	NaN	NaN	NaN	41.89	-87.64	41.92	-87.64	casual	14.0	3.3359
2	E6F2BC47B65CB7FD	electric_bike	2022-08-08 15:29:50	2022-08-08 15:40:34	NaN	NaN	NaN	NaN	41.97	-87.69	41.97	-87.66	casual	10.0	2.4802
3	F597830181C2E13C	electric_bike	2022-08-08 02:43:50	2022-08-08 02:58:53	NaN	NaN	NaN	NaN	41.94	-87.65	41.97	-87.69	casual	15.0	4.6977
4	0CE689BB4E313E8D	electric_bike	2022-08-07 20:24:06	2022-08-07 20:29:58	NaN	NaN	NaN	NaN	41.85	-87.65	41.84	-87.66	casual	5.0	1.3866
5	BFA7E7CC69860C20	electric_bike	2022-08-08 13:06:08	2022-08-08 13:19:09	NaN	NaN	NaN	NaN	41.79	-87.72	41.82	-87.69	casual	13.0	4.1607
6	68C474A4E92F24B6	electric_bike	2022-08-08 14:02:40	2022-08-08 14:11:36	NaN	NaN	NaN	NaN	41.89	-87.63	41.89	-87.61	casual	8.0	1.6555
7	14A985A3838AA8CC	electric_bike	2022-08-07 20:56:17	2022-08-07 21:14:14	NaN	NaN	NaN	NaN	41.96	-87.68	41.92	-87.68	casual	17.0	4.4478
8	E724B94BCE2E7E36	electric_bike	2022-08-07 21:30:05	2022-08-07 21:41:28	NaN	NaN	NaN	NaN	41.92	-87.68	41.93	-87.72	casual	11.0	3.4911
9	1AA3756A6F8189DB	electric_bike	2022-08-07 23:53:05	2022-08-08 00:04:14	NaN	NaN	NaN	NaN	41.93	-87.72	41.92	-87.68	casual	11.0	3.4911

Last rows

	ride_id	rideable_type	started_at	ended_at	start_station_name	start_station_id	end_station_name	end_station_id	start_lat	start_lng	end_lat	end_lng	member_casual	duration_in_mins	distance_km
6081631	6DEFEFE78E1277D1	classic_bike	2023-01-09 12:31:57	2023-01-09 12:44:30	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902973	-87.631280	41.920771	-87.663712	casual	12.0	3.3345
6081632	0CB0D8048D672CE7	electric_bike	2023-01-04 17:30:21	2023-01-04 17:42:12	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902875	-87.631781	41.920771	-87.663712	casual	11.0	3.3078
6081633	8D7369B7FE52D037	electric_bike	2023-01-20 18:21:26	2023-01-20 18:55:42	Ogden Ave & Congress Pkwy	13081	Clarendon Ave & Gordon Ter	13379	41.874960	-87.673230	41.957867	-87.649505	member	34.0	9.4254
6081634	920FD3D051E63678	electric_bike	2023-01-17 18:39:41	2023-01-17 19:00:33	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902781	-87.631663	41.920771	-87.663712	casual	20.0	3.3218
6081635	A3DC3E8358DB1FAA	electric_bike	2023-01-17 18:36:00	2023-01-17 19:00:26	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902760	-87.631491	41.920771	-87.663712	casual	24.0	3.3347
6081636	A303816F2E8A35A8	electric_bike	2023-01-11 17:46:23	2023-01-11 17:57:31	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902634	-87.631591	41.920771	-87.663712	casual	11.0	3.3365
6081637	BCDBB142CC610382	classic_bike	2023-01-30 15:08:10	2023-01-30 15:33:26	Western Ave & Leland Ave	TA1307000140	Clarendon Ave & Gordon Ter	13379	41.966400	-87.688704	41.957867	-87.649505	member	25.0	3.3771
6081638	7D1C7CA80517183B	classic_bike	2023-01-06 19:34:50	2023-01-06 19:50:01	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902973	-87.631280	41.920771	-87.663712	casual	15.0	3.3345
6081639	1A4EB636346DF527	classic_bike	2023-01-13 18:59:24	2023-01-13 19:14:44	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902973	-87.631280	41.920771	-87.663712	casual	15.0	3.3345
6081640	069971675AC7DC62	electric_bike	2023-01-02 13:48:29	2023-01-02 13:59:29	Clark St & Elm St	TA1307000039	Southport Ave & Clybourn Ave	TA1309000030	41.902822	-87.631687	41.920771	-87.663712	casual	11.0	3.3175

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block